<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCaCustomerLogs extends \App\Utils\CreateMigration
{
    function columns(Blueprint $table)
    {
        $table->unsignedBigInteger('user_id')->default(0)->comment('用户ID');
        $table->unsignedBigInteger('customer_id')->default(0)->comment('客户ID');
        $table->string('desc')->nullable()->comment('描述');
        $table->longText('change_data')->nullable()->comment('变更日志');
        $table->index(['customer_id'], 'idx_customer');
    }

    function tableInfo()
    {
        return ['ca__customer_logs', '咨询预约-客户信息变更日志'];
    }
}
